# -*- coding: utf-8 -*-
# @Time    : 2024/12/9  15:36
# @Author  : Nabby
# @FileName: jasco_forecast_information.py
# @Desc    : 货物预报信息


from app import db, loginmanager
from datetime import datetime


class JascoForecastInformation(db.Model):
    __tablename__ = 'jasco_forecast_information'
    id = db.Column(db.Integer, primary_key=True)
    cargo_code = db.Column(db.String(50), unique=True, index=True, comment='货箱编号')
    length = db.Column(db.String(20), comment='长')
    width = db.Column(db.String(20), comment='宽')
    height = db.Column(db.String(20), comment='高')
    gross_weight = db.Column(db.String(20), comment='毛重')
    volume = db.Column(db.String(20), comment='体积')
    order_id = db.Column(db.Integer, db.ForeignKey('jasco_order.id'), comment='订单id')
    create_time = db.Column(db.DateTime, default=datetime.now)
    update_time = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)



